ALTER TABLE `rule_in`
    ADD COLUMN `kycapiname` varchar(20) NULL COMMENT '实名接口' AFTER `apply_sucess_hour`,
ADD COLUMN `regphoneoperator` varchar(20) NULL COMMENT '注册手机号运行商' AFTER `kycapiname`,
ADD COLUMN `bvnphoneoperator` varchar(20) NULL COMMENT 'BVN手机号运行商' AFTER `regphoneoperator`,
ADD COLUMN `kycbirthmatch` varchar(20) NULL COMMENT 'KYC生日匹配类型' AFTER `bvnphoneoperator`,
ADD COLUMN `diffpayandbill` varchar(20) NULL COMMENT '发薪日与账单日差' AFTER `kycbirthmatch`,
ADD COLUMN `creditmodellevel` varchar(20) NULL COMMENT '授信模型等级' AFTER `diffpayandbill`;

ALTER TABLE `rule_in`
    ADD COLUMN `reporttype` varchar(20) NULL COMMENT '报告类型' AFTER `creditmodellevel`;


-- ALTER TABLE `sms_area_number_config`
-- DROP COLUMN `response_code`,
-- DROP COLUMN `sms_content`,
-- MODIFY COLUMN `create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '创建人' AFTER `remark`;

/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : 192.168.1.179:3307
 Source Schema         : pdl_sit

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 18/05/2022 12:29:55
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sms_area_number_config
-- ----------------------------
DROP TABLE IF EXISTS `sms_area_number_config`;
CREATE TABLE `sms_area_number_config`
(
    `id`                 bigint(20) NOT NULL AUTO_INCREMENT COMMENT '配置主键',
    `area_number`        varchar(30)   NOT NULL COMMENT '电话号段',
    `sms_marketing_mode` varchar(1000) NOT NULL COMMENT '短信方式配置id（;分隔）',
    `status`             int(1) unsigned zerofill NOT NULL DEFAULT '0' COMMENT '状态 1：生效，0失效',
    `remark`             varchar(255)           DEFAULT NULL COMMENT '备注',
    `create_by`          varchar(20)            DEFAULT NULL COMMENT '创建人',
    `create_time`        timestamp     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_by`          bigint(20) DEFAULT NULL COMMENT '更新人',
    `update_time`        timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `area_number` (`area_number`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sms_area_number_config
-- ----------------------------
BEGIN;
INSERT INTO `sms_area_number_config`
VALUES (43, '0703', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (44, '0706', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (45, '0803', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (46, '0806', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (47, '0810', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (48, '0813', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (49, '0814', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (50, '0816', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (51, '0903', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (52, '0702', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (53, '0704', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (54, '0906', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (55, '0913', 'MTN', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (56, '0701', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (57, '0708', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (58, '0802', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (59, '0808', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (60, '0812', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (61, '0901', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (62, '0902', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (63, '0907', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (64, '0904', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (65, '0912', 'AIRTLE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (66, '0705', 'GLO', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (67, '0805', 'GLO', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (68, '0807', 'GLO', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (69, '0811', 'GLO', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (70, '0815', 'GLO', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (71, '0905', 'GLO', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (72, '0915', 'GLO', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (73, '0809', '9MOBLIE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (74, '0817', '9MOBLIE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (75, '0818', '9MOBLIE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (76, '0908', '9MOBLIE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
INSERT INTO `sms_area_number_config`
VALUES (77, '0909', '9MOBLIE', 0, NULL, NULL, '2022-05-09 14:49:06', NULL, '2022-05-09 14:49:06');
COMMIT;

SET
FOREIGN_KEY_CHECKS = 1;



ALTER TABLE `customer_info`
    ADD COLUMN `credit_model_level` varchar(20) NULL COMMENT '授信模型评级' AFTER `credit_rating`;

ALTER TABLE `rule_out`
    ADD COLUMN `creditmodellevel` varchar(10) NULL COMMENT '授信模型评级' AFTER `promotion`;